#pragma once
#include "stdafx.h"

class CreateTableHelper
{
public:
	CreateTableHelper(void);
	~CreateTableHelper(void);

	_ConnectionPtr m_spCon;	

	void CreateAdoTable(_ConnectionPtr& spCon_oracle,std::set<CString>& vtTables,_ConnectionPtr& spCon_mdb);
	CString GetFieldType(CString sType);


	//void CreateAdoTable();
// 	CString GetCreateFieldSql(MSXML2::IXMLDOMElementPtr &spField);
// 	CString GetCreateTBSQL(MSXML2::IXMLDOMElementPtr &spTable);

	//CString GetXmlAtt(MSXML2::IXMLDOMElementPtr &spEle,CString sName)
	//{
	//	_variant_t vValue;
	//	spEle->raw_getAttribute(_bstr_t(sName),&vValue);
	//	CString sValue = VariantToStr(vValue);
	//	return sValue.MakeUpper();
	//}

	std::map<CString,CString>	m_mapTableFields;


	CString ExportSdeTable(CString sMdbPath,esriCore::IFeatureWorkspacePtr spFeaWork,CString& sUserName);

	std::set<CString> GetSdeTable(CString& sUserName);
};
